<?php
$con = mysql_connect("localhost","root","root");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("comld", $con);
$dateTime = date("Y-m-d",strtotime("-1 day"));

mysql_query("INSERT INTO comld SELECT NULL, _499cents1,
  _499cents2,
  _299cents1,
  _199cents1,
  _099cents1,
  _099cents2,
  _999cents1,
  _999cents2,
  _1999cents1,
  _1999cents2,
  _9999cents1,
  _9999cents2,
  _4999cents1,
  _4999cents2,
  _199cents2,
  _299cents2,
  nGoldGainFromGameToday,
  nGoldConsumeToday,
  nGameOverToday,
  arrItemConsumeToday,
  InnoKiller,
  LandMine,
  AirStrike,
  Tower,
  TowerBullet,
  nLoginTimesToday,
  ltWeaponBuyToday,
  nGoldGainFromIAPToday,
  fGameTimeToday,
  nTCGainToday,
  InnoKiller_arrItemBuyToday,
  LandMine_arrItemBuyToday,
  AirStrike_arrItemBuyToday,
  Tower_arrItemBuyToday,
  TowerBullet_arrItemBuyToday,
  nTCConsumeToday,
  nStartGameToday,
  ltGameBreakOutToday,
  totalarrScene,
  Credit,
  Ready,
  Menu,
  Map,
  Help,
  options,
  IAP,
  Shop,
  Scene0,
  Scene1,
  totalnGoldGainTotal,
  totalltWeapon,
  FirstLoginTime,
  totalfGameTimeTotal,
  totalnTCGainTotal,
  totalnTCNow,
  totalarrItem,
  InnoKiller_totalarrItem,
  LandMine_totalarrItem,
  AirStrike_totalarrItem,
  Tower_totalarrItem,
  TowerBullet_totalarrItem,
  totalnGoldNow,
  Jailbreak,
  deviceid,
  whatdate,
  gamename,
  createdate,
  date   FROM  comld_query_temp");

mysql_close($con);
?>